﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using FortuneHeavenCommon.ComMethod;

namespace FortuneHeavenCommon.DataMap
{
    public partial class AccountsInfo
    {
        public const string TABLE_NAME = "AccountsInfo";
        public const string INSERT_SQL = "insert into AccountsInfo([GameID],[ProtectID],[Accounts],[RegAccounts],[UnderWrite],[LogonPass],[InsurePass],[SpreaderID],[FaceID],[Experience],[UserRight],[MasterRight],[ServiceRight],[MasterOrder],[MemberOrder],[MemberOverDate],[Loveliness],[Gender],[Nullity],[StunDown],[MoorMachine],[MachineSerial],[WebLogonTimes],[GameLogonTimes],[RegisterIP],[LastLogonIP],[RegisterDate],[LastLogonDate],[CustomFaceVer],Add_MobilePhone ,Add_BankID,Add_BankName,Add_Area,Add_RealName,Add_IDNumber) values (@GameID,@ProtectID,@Accounts,@RegAccounts,@UnderWrite,@LogonPass,@InsurePass,@SpreaderID,@FaceID,@Experience,@UserRight,@MasterRight,@ServiceRight,@MasterOrder,@MemberOrder,@MemberOverDate,@Loveliness,@Gender,@Nullity,@StunDown,@MoorMachine,@MachineSerial,@WebLogonTimes,@GameLogonTimes,@RegisterIP,@LastLogonIP,@RegisterDate,@LastLogonDate,@CustomFaceVer,@Add_MobilePhone,@Add_BankID,@Add_BankName,@Add_Area,@Add_RealName,@Add_IDNumber)";
        public const string UPDATE_SQL = "UPDATE AccountsInfo SET [GameID]=@GameID,[ProtectID]=@ProtectID,[Accounts]=@Accounts,[RegAccounts]=@RegAccounts,[UnderWrite]=@UnderWrite,[LogonPass]=@LogonPass,[InsurePass]=@InsurePass,[SpreaderID]=@SpreaderID,[FaceID]=@FaceID,[Experience]=@Experience,[UserRight]=@UserRight,[MasterRight]=@MasterRight,[ServiceRight]=@ServiceRight,[MasterOrder]=@MasterOrder,[MemberOrder]=@MemberOrder,[MemberOverDate]=@MemberOverDate,[Loveliness]=@Loveliness,[Gender]=@Gender,[Nullity]=@Nullity,[StunDown]=@StunDown,[MoorMachine]=@MoorMachine,[MachineSerial]=@MachineSerial,[WebLogonTimes]=@WebLogonTimes,[GameLogonTimes]=@GameLogonTimes,[RegisterIP]=@RegisterIP,[LastLogonIP]=@LastLogonIP,[RegisterDate]=@RegisterDate,[LastLogonDate]=@LastLogonDate,[CustomFaceVer]=@CustomFaceVer,Add_MobilePhone =@Add_MobilePhone,Add_BankID =@Add_BankID,Add_BankName=@Add_BankName,Add_Area=@Add_Area,Add_RealName=@Add_RealName,Add_IDNumber=@Add_IDNumber where UserID = @UserID";

        /// <summary>
        ///
        /// </summary>
        [PrimaryKey]
        public int UserID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int GameID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int ProtectID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string Accounts
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string RegAccounts
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string UnderWrite
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
          [TableFieldd]
        public string LogonPass
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string InsurePass
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int SpreaderID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int FaceID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int Experience
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int UserRight
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int MasterRight
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int ServiceRight
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int MasterOrder
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int MemberOrder
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public DateTime MemberOverDate
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
       [TableFieldd]
        public int Loveliness
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int Gender
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public bool Nullity
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public bool StunDown
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int MoorMachine
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string MachineSerial
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int WebLogonTimes
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int GameLogonTimes
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string RegisterIP
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public string LastLogonIP
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public DateTime RegisterDate
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public DateTime LastLogonDate
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        [TableFieldd]
        public int CustomFaceVer
        {
            get;
            set;
        }

        public string Add_RealName
        {
            get;
            set;
        }

        public string Add_Area
        {
            get;
            set;
        }

        public string Add_BankName
        {
            get;
            set;
        }

        public string Add_BankID
        {
            get;
            set;
        }
        public string Add_MobilePhone
        {
            get;
            set;
        }

        public string Add_IDNumber
        {
            get;
            set;
        }
    }

}
